[SQL]

There are currently four products that may make use this section.

• The SQL interpreter uses this section for replacement [trmw] entries in the same way as other DP4 programs

• Three ADCs that implement the DP4 database as a client of OEM databases.

  • Auxwodbc
  • Auxoracl
  • Auxwsybas

The AUXWODBC ADC (Auxiliary Database Controller) provides seamless access to foreign ODBC compliant Databases. The necessary information for the .INI files can be created by AUXWINST, and is categorised below. Fuller installation details are contained in the SQLODBC help file.

The AUXORACL ADC provides access to Oracle databases, using native Oracle calls rather than the ODBC interface. Further information is contained in the DP4 SQL Products manual.

AUXSYBAS ADC is a similar product to AUXORACL, but for Sybase databases.

Entries in the [SQL] section

The DP4 configuration file should contain one [sql] section with one or more lines, each of which specifies a connection between a DP4 database and an OEM data source. The format of these entries is dependent on which of the above ADCs is used to access that database, and, for AUXWODBC, the type of ODBC source.

For example, an ODBC connection to a Microsoft database using auxwodbc might be specified like this:

DF7=DSN=Sample database;DBQ=MS7;UID=SCOTT;PWD=tiger

Where ;DF7 is the DP4 database name, Sample database is the ODBC data source name, MS7 is the name of the foreign database, SCOTT is the user identity for the database and tiger is the password. The DP4 database and ODBC data source names always appear as in the above example, but other details will vary depending on the ODBC server.

For Oracle and Sybase (using the native Gateway ADCs rather than the ODBC Gateway) the connect string will have the following form:

db=user/password@service

For example: df7=scott/tiger@ora

Associated entries in other general sections:

[STARTUP]

The startup section will include a command to load the appropriate ADC, for example as follows:

[startup]
1=dp4srvr.w32 -aux
2=auxoracl.w32

[DEBUG]

The debug section has an entry to allow debug output from AUXxxxxx to be displayed in the errlog program and/or to be output to a file. The format is as follows:

[debug]
debug_auxsql=n

This has the usual format for being set to 1 for on and 0 for off. If set to 2 or 3 more detailed diagnostic information is produced.

Note that turning on diagnostics should only be done during problem investigation. These diagnostics may significantly degrade performance.

Each of these ADCs may also make use of the following sections:

• [sql.config DP4_database_name]
• [sql.remote DP4_database_name]
• [sql.xlat DP4_database_name]

The DP4 SQL Engine uses the following section, which may be useful when converting a system to use DP4 rather than a non DP4 database:

• [sql.xlat2 DP4_database_name]

There are also product specific sections for each ADC:

• auxwodbc [AUXWODBC]
• auxoracl [ORACLE]
• auxsybas [SYBASE]